import openpyxl
myBook=openpyxl.load_workbook('竞猜表.xlsx')
mySheet=myBook.active
myRows=list(mySheet.rows)[1:]
for myRow in myRows:
	myStr=myRow[1].value
	if set(myStr.split('、'))=={'20号','25号','27号','33号','38号'}:
		myRow[2].value='√'
	else:
		myRow[2].value='×'
myBook.save('结果表-竞猜表.xlsx')
